USE [ventas]
GO

/****** Object:  Table [saventa].[post_venta_table]    Script Date: 09/26/2012 09:45:34 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[saventa].[post_venta_table]') AND type in (N'U'))
DROP TABLE [saventa].[post_venta_table]
GO

USE [ventas]
GO

/****** Object:  Table [saventa].[post_venta_table]    Script Date: 09/26/2012 09:45:34 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [saventa].[post_venta_table](
	[IdProyecto] [varchar](10) NULL,
	[idUrbanizacion] [varchar](5) NULL,
	[idempresa] [varchar](15) NULL,
	[Categoria] [varchar](5) NULL,
	[EstadoLote] [varchar](5) NULL,
	[EstadoLotePro] [varchar](5) NULL,
	[Mz] [varchar](5) NULL,
	[Lote] [varchar](5) NULL,
	[Modelo] [varchar](255) NULL,
	[Contrato] [varchar](15) NULL,
	[Fec_entrega] [datetime] NULL,
	[ConstructorId] [varchar](15) NULL,
	[NombreConst] [varchar](100) NULL,
	[EquipadorId] [varchar](15) NULL,
	[NombreEqui] [varchar](100) NULL,
	[id_tipo_cliente] [char](2) NULL,
	[id_cliente] [varchar](15) NULL,
	[Identificacion] [varchar](15) NULL,
	[Nombre] [varchar](100) NULL,
	[Apellido] [varchar](100) NULL,
	[Direccion] [varchar](150) NULL,
	[Correo] [varchar](140) NULL,
	[Telefono1] [varchar](21) NULL,
	[Telefono2] [varchar](21) NULL,
	[Oficial_venta] [varchar](60) NULL,
	[Oficial_credito] [varchar](255) NULL,
	[estado_reg] [char](1) NULL,
	[fecha_modif] [datetime] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


